To Create a Database Connection
- Right-click the Database node and select Connect Database.
-
Select the method to be used to connect to the data source:
- For ODBC, enter the ODBC name defined in the Windows ODBC Datasource Administrator.
- For OLEDB, use the file navigation tool to navigate to the Universal Data Link (UDL) file for your data source.
- For Oracle, enter the Oracle service name.
- Enter a username and password if any of these methods require it.
The connection is established and an overview tab displays the database tables. This database can now be used when defining RDBMS properties on features.
If the database structure changes, it can be refreshed in the project by selecting the Database node and selecting Update.
Importing a MicroStation GeoGraphics project creates a database connection automatically.
Note: Possible reasons for failure to connect to the database:- Database does not have an MSCATALOG table. See the directions above for adding an MSCATALOG table.
- Username and password is incorrect. Verify with database administrator or alternate method to connect to database.
- ODBC name is not defined correctly or does not point to a valid database. Verify ODBC setup by using Windows ODBC Datasource Administrator .
- The proper Oracle services are not running so the database is inaccessible. Check connection by using SQLPLUS .
